package me.zhengjie.modules.finace_taxation.service.mapper;

import me.zhengjie.base.CommonMapper;
import me.zhengjie.modules.finace_taxation.domain.FtUsers;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
* @author 杨荣森
* @date 2021-06-28
*/
@Repository
public interface FtUsersMapper extends CommonMapper<FtUsers> {

    /*根据用户openid查询用户是否存在*/
    @Select("select count(*) from ft_users where openid = #{openId}")
    int getFtUserByWXOpenid(String openId);


    /*根据openid查询用户信息*/
    @Select("select * from ft_users where openid = #{openId}")
    FtUsers getFtUserByopenid(String openId);
}
